-
Re: Show Percentage from Sheet as Pie Chart in Dashboard
Hi @Brandon29 You're correct that a Chart in a Dashboard cannot map a single value like this to show percents. You'll need to have the second half of the value (what is the remaining percent to make …5 · -
Re: Welcome to Just for fun - let's post some memes!
13 · -
Re: Index Match Formula Help
Hi @Jake Gustafson You could use a VLOOKUP, you're correct! However I personally prefer INDEX(MATCH because it evaluates the two columns separately. In a VLOOKUP you put in one range that spans acros…6 · -
Re: Invalid Data Types
Hi @Amy Shank Try simply: =AVG([LE Total Days]:[LE Total Days]) AVG won't be able to identify extra criteria, you would either need to use AVERAGEIF or AVG(COLLECT. If you want to try filtering cells…5 · -
Re: How to answer directly to Commenter ?
Hi @lkrobot Are you referring to conversations in the Smartsheet Application, or here in the Community? Here in the Community, you can adjust your notification settings in order to be alerted wheneve…5 ·